package com.itheima.mapper;

import com.github.pagehelper.Page;
import com.itheima.pojo.EmpLoginLog;
import com.itheima.pojo.OperateLog;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface OperateLogMapper {

    //插入日志数据
    @Insert("insert into operate_log (operate_emp_id, operate_time, class_name, method_name, method_params, return_value, cost_time) " +
            "values (#{operateEmpId}, #{operateTime}, #{className}, #{methodName}, #{methodParams}, #{returnValue}, #{costTime});")
    void insert(OperateLog log);


    //插入登录日志数据
    @Insert("insert into emp_login_log (username, password, login_time, is_success, jwt, cost_time) values " +
            "(#{username}, #{password}, #{loginTime}, #{isSuccess},#{jwt},#{costTime})")
    void add(EmpLoginLog empLoginLog);





//    分页查询
    @Select("select e.name operateEmpName,o.* from operate_log o,emp e where o.operate_emp_id = e.id")
    Page<OperateLog> page(Integer page, Integer pageSize);
}
